Private Sub UserForm_Initialize()

    With ScrollBar1
        .Max = 250
        .Min = 100
        .LargeChange = 10
        .SmallChange = 1
    End With

    With SpinButton1
        .Max = 100
        .Min = 50
    End With

End Sub